<?php
  require_once('nav.php');
?>
        <div class="col-sm-9 col-md-10">
          <?php
            //编写sql语句
            $sql = 'select uid, uname, gender, birthday, hobby, degree, intro, pic from users';
            //echo $sql.'<br/>';  
            $result = fetch_array($sql);
          ?>
          <center><h3>用户列表</h3></center>
         <table class="table table-hover"> 
         <tr>
           <th>用户编号</th>
           <th>用户名</th>   
           <th>性别</th>
           <th>生日</th>
           <th>爱好</th>
           <th>学历</th>
           <th>自我介绍</th> 
           <th width='80'>头像</th>
           <th>操作</th>
         </tr>

         <?php
          foreach ($result as $row) {
           echo '<tr>';
           echo '<td>'.$row['uid'].'</td>';
           echo '<td>'.$row['uname'].'</td>';  
           echo '<td>'.($row['gender']==0?'男':'女').'</td>';
           echo '<td>'.$row['birthday'].'</td>';
           echo '<td>'.$row['hobby'].'</td>';
           switch($row['degree']){
             case '1':$dg = "高中";break;
             case '2':$dg = "大学";break;
             case '3':$dg = "研究生";break;
             case '4':$dg = "博士生";break;
             default: $dg="不知道";
             }
           echo '<td>'.$dg.'</td>';
           echo '<td>'.$row['intro'].'</td>';    
           echo '<td align="center"><img src='.$row['pic'].' width=60 height=80 alt="无头像"></td>';  
           echo '<td><a href="userEditForm.php?id='.$row['uid'].' ">修改</a> | 
           <a href="userDelete.php?id='.$row['uid'].'" onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';
           echo '</tr>';  
          }
          echo '</table>';  
          $totalrows = count($result);
          echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>";   
         ?>

        </div>
      <?php
        require_once('footer.php');
      ?>
